import pandas as pd

df =pd.read_excel(r'C:\Users\Administrator\Desktop\test_blank.xlsx')

def getColumns(dataFrame):
    columns = []
    for column in dataFrame.index:
        columns.append(column)

    return columns

def getValuesName(dataFrame):
    v_name = []
    for name in dataFrame.columns:
        v_name.append(name)

    return v_name

def getValues(dataFrame):
    values = []
    for i in range(len(dataFrame.columns)):
        name = dataFrame.columns[i]
        obj = {}
        obj[name] = []

        for value in dataFrame.values:
            obj[name].append(value[i])

        values.append(obj)

    return values

values = ['收入','日期']
columns = ['业务员']

df_groupby = df.groupby(columns)

res = df_groupby[values].count()

print(res)
